home *** CD-ROM | disk | FTP | other *** search
/ Multicollection 5 Soft 1997 / Multicollection 5 soft 1997 (Win NT 4.0 Work, Serv, OS2).iso / nt40_wrk / inetsrv / scripts / samples / query.idc < prev    next >
Encoding:
Text File  |  1996-02-12  |  396 b   |  15 lines
  1. Datasource: Web SQL
  2. Username: sa
  3. Template: query.htx
  4. SQLStatement:
  5. +SELECT FirstName, LastName
  6. +FROM Guests
  7. +WHERE FirstName like '%FirstName%'
  8. +and LastName like '%LastName%'
  9. +and (WebUse like '%WebMaster%'
  10. +  or WebUse like '%WebSurfer%'
  11. +  or WebUse like '%ISV%'
  12. +  or WebUse like '%ContentProvider%'
  13. +  or WebUse like '%WebIntegrator%')
  14. DefaultParameters:FirstName=%,LastName=%
  15.